{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Summary","Current Assets (Farm)","Intermediate Assets (Farm)","Long Term Assets (Farm)","Liabilities (Farm)","Assets (Personal)","Liabilities (Personal)","Financial Ratios"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[44,1,44,5],[0,1,0,5],[3,1,3,5],[1,1,1,5],[2,3,2,5],[2,1,2,2],[9,11,9,17],[8,11,8,17],[7,11,7,17],[1,11,2,17],[28,1,28,5]]}
[null,"Balance Sheet"]
[null,null,null,null,null,null,null,null,null,null,null,"Farm Balance Sheet Template"]
[null,"Date",null,"Farm Name"]
[null,"FARM"]
[null,"Current Assets",null,null,"Current Liabilities"]
[null,"Cash",{"$f":"'Current Assets (Farm)'!B9","v":0},null,"Accounts Payable",{"$f":"'Liabilities (Farm)'!C23","v":0}]
[null,"Prepaid Expenses & Supplies",{"$f":"'Current Assets (Farm)'!D33","v":0},null,"Current Principal Due",{"$f":"SUM('Liabilities (Farm)'!F37,'Liabilities (Farm)'!F61,'Liabilities (Farm)'!F85)","v":0}]
[null,"Growing Crops",{"$f":"'Current Assets (Farm)'!E52","v":0},null,"Interest Accrual",{"$f":"SUM('Liabilities (Farm)'!G37,'Liabilities (Farm)'!G61,'Liabilities (Farm)'!G85)","v":0},null,null,null,null,null,"Prepared by: Jon LaPorte, Farm Business Management Educator"]
[null,"Accounts Receivable",{"$f":"'Current Assets (Farm)'!E71","v":0},null,null,null,null,null,null,null,null,"Suite 116, 120 N. Broadway, Cassopolis, MI 49031"]
[null,"Crop Inventory",{"$f":"'Current Assets (Farm)'!F90","v":0},null,null,null,null,null,null,null,null,"Phone: (269) 445-4356          Email: laportej@msu.edu"]
[null,"Livestock Held for Sale",{"$f":"'Current Assets (Farm)'!F109","v":0}]
[null,"Other Assets",{"$f":"'Current Assets (Farm)'!C123","v":0}]
[null,"Total Current Assets",{"$f":"SUM(C6:C12)","v":0},null,"Total Current Liabilities",{"$f":"SUM(F6:F12)","v":0}]
[]
[null,"Intermediate Assets",null,null,"Intermediate Liabilities"]
[null,"Machinery & Equipment",{"$f":"'Intermediate Assets (Farm)'!H63","v":0},null,"Non-Current Principal",{"$f":"'Liabilities (Farm)'!I61","v":0}]
[null,"Farm Vehicles",{"$f":"'Intermediate Assets (Farm)'!H82","v":0}]
[null,"Breeding Livestock",{"$f":"'Intermediate Assets (Farm)'!H101","v":0}]
[null,"Other Assets",{"$f":"'Intermediate Assets (Farm)'!D115","v":0}]
[null,"Total Intermediate Assets",{"$f":"SUM(C16:C19)","v":0},null,"Total Intermediate Liabilities",{"$f":"SUM(F16:F19)","v":0}]
[]
[null,"Long Term Assets",null,null,"Long Term Liabilities"]
[null,"Buildings & Improvements",{"$f":"'Long Term Assets (Farm)'!D24","v":0},null,"Non-Current Principal",{"$f":"'Liabilities (Farm)'!I85","v":0}]
[null,"Real Estate",{"$f":"'Long Term Assets (Farm)'!H49","v":0}]
[null,"Other Long-Term Assets",{"$f":"'Long Term Assets (Farm)'!D64","v":0}]
[null,"Total Long-Term Assets",{"$f":"SUM(C23:C25)","v":0},null,"Total Long-Term Liabilities",{"$f":"SUM(F23:F24)","v":0}]
[null,"TOTAL FARM ASSETS",{"$f":"SUM(C26,C20,C13)","v":0},null,"TOTAL FARM LIABILITIES",{"$f":"SUM(F26,F20,F13)","v":0}]
[null,null,null,null,"OWNER EQUITY (FARM)",{"$f":"C27-F27","v":0}]
[null,"PERSONAL"]
[null,"Current Assets",null,null,"Current Liabilities"]
[null,"Cash",{"$f":"'Assets (Personal)'!B13","v":0},null,"Accounts Payable",{"$f":"'Liabilities (Personal)'!C13","v":0}]
[null,"Life Insurance",{"$f":"'Assets (Personal)'!D28","v":0},null,"Current Portion Due",{"$f":"SUM('Liabilities (Personal)'!F28,'Liabilities (Personal)'!F43,'Liabilities (Personal)'!F58)","v":0}]
[null,"Retirement Account",{"$f":"'Assets (Personal)'!D43","v":0},null,"Interest Accrual",{"$f":"SUM('Liabilities (Personal)'!G28,'Liabilities (Personal)'!G43,'Liabilities (Personal)'!G58)","v":0}]
[null,"Total Current Assets",{"$f":"SUM(C31:C33)","v":0},null,"Total Current Liabilities",{"$f":"SUM(F31:F33)","v":0}]
[]
[null,"Intermediate Assets",null,null,"Intermediate Liabilities"]
[null,"Personal Vehicles",{"$f":"'Assets (Personal)'!G58","v":0},null,"Non-Current Principal",{"$f":"'Liabilities (Personal)'!I43","v":0}]
[null,"Total Intermediate Assets",{"$f":"SUM(C37)","v":0},null,"Total Intermediate Liabilities",{"$f":"SUM(F37)","v":0}]
[]
[null,"Long-Term Assets",null,null,"Long Term Liabilities"]
[null,"Real Estate",{"$f":"'Assets (Personal)'!G73","v":0},null,"Non-Current Principal",{"$f":"'Liabilities (Personal)'!I58","v":0}]
[null,"Total Long-Term Assets",{"$f":"SUM(C41)","v":0},null,"Total Long-Term Liabilities",{"$f":"SUM(F41)","v":0}]
[null,"TOTAL PERSONAL ASSETS",{"$f":"SUM(C42,C38,C34)","v":0},null,"TOTAL PERSONAL LIABILITIES",{"$f":"SUM(F42,F38,F34)","v":0}]
[null,null,null,null,"OWNER EQUITY (PERSONAL)",{"$f":"C43-F43","v":0}]
[null,"FARM & PERSONAL"]
[null,"TOTAL ASSETS",{"$f":"SUM(C27,C43)","v":0},null,"TOTAL LIABILITIES",{"$f":"SUM(F27,F43)","v":0}]
[null,null,null,null,"OWNER EQUITY",{"$f":"SUM(F44,F28)","v":0}]

{"sheet":"Current Assets (Farm)","index":1,"n_rows":123,"n_cols":6,"rows_kept":123,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Farm Cash-On-Hand"]
["Description","Amount"]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
["Total Cash",{"$f":"SUM(B3:B8)","v":0}]
[]
["Pre-Paid Expenses & Supplies"]
["Input Description","Amount","Cost/Input","Total Value"]
[null,0,0,{"$f":"C13*B13","v":0}]
[null,0,0,{"$f":"C14*B14","v":0}]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
["Total Pre-Paid Expenses",null,null,{"$f":"SUM(D13:D32)","v":0}]
[]
["Growing Crops"]
["Crop","Unit","Acres","Cost/Acre","Total Value"]
[null,null,0,0,{"$f":"D37*C37","v":0}]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
["Total Growing Crops",null,null,null,{"$f":"SUM(E37:E51)","v":0}]
[]
["Accounts Receivable"]
["Account Name","Description","Amount","Cost/Input","Total Receivable"]
[null,null,0,0,{"$f":"D56*C56","v":0}]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
["Total Receivables",null,null,null,{"$f":"SUM(E56:E70)","v":0}]
[]
["Crop Inventory"]
["Crop","Description","Unit","Amount","Price/Unit","Total Value"]
[null,null,null,0,0,{"$f":"E75*D75","v":0}]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
["Total Inventory",null,null,null,null,{"$f":"SUM(F75:F89)","v":0}]
[]
["Livestock Held For Sale"]
["Livestock","Description","Number of Head","Average Weight","Value Per Unit","Total Value"]
[null,null,0,0,0,{"$f":"E94*C94","v":0}]
[null,null,0,0,0,{"$f":"E95*C95","v":0}]
[null,null,0,0,0,0]
[null,null,0,0,0,0]
[null,null,0,0,0,0]
[null,null,0,0,0,0]
[null,null,0,0,0,0]
[null,null,0,0,0,0]
[null,null,0,0,0,0]
[null,null,0,0,0,0]
[null,null,0,0,0,0]
[null,null,0,0,0,0]
[null,null,0,0,0,0]
[null,null,0,0,0,0]
[null,null,0,0,0,0]
["Total Inventory",null,null,null,null,{"$f":"SUM(F94:F108)","v":0}]
[]
["Other Current Assets"]
["Asset Description","Amount","Total Value"]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
["Total Other Assets",null,{"$f":"SUM(C113:C122)","v":0}]

{"sheet":"Intermediate Assets (Farm)","index":2,"n_rows":115,"n_cols":8,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
["Machinery & Equipment"]
["Item Description","Make","Model","Year","Serial #","Ownership %","Total Cost Value","Total Market Value"]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
["Total M&E",null,null,null,null,null,{"$f":"SUM(G3:G62)","v":0},{"$f":"SUM(H3:H62)","v":0}]
[]
["Farm Vehicle"]
["Item Description","Make","Model","Year","Serial #","Ownership %","Total Cost Value","Total Market Value"]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
["Total Farm Vehicles",null,null,null,null,null,{"$f":"SUM(G67:G81)","v":0},{"$f":"SUM(H67:H81)","v":0}]
[]
["Breeding Livestock"]
["Description","Quantity","Year Purchased","Total Purchase Price","Cost Value per Unit","Market Value per Unit","Total Cost Value","Total Market Value"]
[null,0,null,null,0,0,{"$f":"E86*B86","v":0},{"$f":"F86*B86","v":0}]
[null,0,null,null,0,0,{"$f":"E87*B87","v":0},{"$f":"F87*B87","v":0}]
[null,0,null,null,0,0,0,0]
[null,0,null,null,0,0,0,0]
[null,0,null,null,0,0,0,0]
[null,0,null,null,0,0,0,0]
[null,0,null,null,0,0,0,0]
[null,0,null,null,0,0,0,0]
[null,0,null,null,0,0,0,0]
[null,0,null,null,0,0,0,0]
[null,0,null,null,0,0,0,0]
[null,0,null,null,0,0,0,0]
[null,0,null,null,0,0,0,0]
[null,0,null,null,0,0,0,0]
[null,0,null,null,0,0,0,0]
["Total Breeding Livestock",null,null,null,{"$f":"SUM(E86:E100)","v":0},{"$f":"SUM(F86:F100)","v":0},{"$f":"SUM(G86:G100)","v":0},{"$f":"SUM(H86:H100)","v":0}]
[]
["Other Intermediate Assets"]
["Asset Description","Quantity","Total Cost Value","Total Market Value"]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
["Total Other Intermediate Assets",null,{"$f":"SUM(C105:C114)","v":0},{"$f":"SUM(D105:D114)","v":0}]

{"sheet":"Long Term Assets (Farm)","index":3,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Buildings & Improvements"]
["Description","Detail","Total Cost Value","Total Market Value"]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
["Total",null,{"$f":"SUM(C3:C23)","v":0},{"$f":"SUM(D3:D23)","v":0}]
[]
[]
["Real Estate"]
["Description","Location","Total Acres","Crop Acres","Cost Value/Acre","Market Value/Acre","Total Cost Value","Total Market Value"]
[null,null,0,0,0,0,{"$f":"C29*E29","v":0},{"$f":"C29*F29","v":0}]
[null,null,0,0,0,0,{"$f":"C30*E30","v":0},{"$f":"C30*F30","v":0}]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
["Total",null,{"$f":"SUM(C29:C48)","v":0},0,0,0,0,0]
[]
[]
["Other Long-Term Assets"]
["Asset Description","Quantity","Total Cost Value","Total Market Value"]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
["Total",null,{"$f":"SUM(C54:C63)","v":0},{"$f":"SUM(D54:D63)","v":0}]

{"sheet":"Liabilities (Farm)","index":4,"n_rows":85,"n_cols":13,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["Accounts Payable"]
["Account Description","Detail","Total Value"]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
["Total",null,{"$f":"SUM(C3:C22)","v":0}]
[]
["Current Loans"]
["Account Description","Loan Purpose","Total Balance","Interest Rate","# of Pmts","Current Principal Due","Accrued Interest","Total Pmt"]
[null,null,0,0,0,{"$f":"H27-G27","v":0},{"$f":"C27*D27","v":0},0]
[null,null,0,0,0,{"$f":"H28-G28","v":0},0,0]
[null,null,0,0,0,0,0,0,null,null,null,"*Note: ","Default accrued interest is calculation of loan balance multipled by interest rate."]
[null,null,0,0,0,0,0,0,null,null,null,null,"To personalize for your farm, enter accured interest amounts based on loan statements."]
[null,null,0,0,0,0,0,0,null,null,null,null,"Reset button will return accrued interest to default calculation."]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
["Total",null,{"$f":"SUM(C27:C36)","v":0},null,null,{"$f":"SUM(F27:F36)","v":0},{"$f":"SUM(G27:G36)","v":0},{"$f":"SUM(H27:H36)","v":0}]
[]
["Intermediate Loans"]
["Account Description","Loan Purpose","Total Balance","Interest Rate","# of Pmts","Current Principal Due","Accrued Interest","Total Annual Pmt","Non-Current Principal","Final Year"]
[null,null,0,0,0,{"$f":"H41-G41","v":0},{"$f":"C41*D41","v":0},0,{"$f":"C41-F41","v":0}]
[null,null,0,0,0,{"$f":"H42-G42","v":0},0,0,{"$f":"C42-F42","v":0}]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
["Total",null,{"$f":"SUM(C41:C60)","v":0},null,null,0,0,0,{"$f":"SUM(I41:I60)","v":0}]
[]
["Long Term Loans"]
["Account Description","Loan Purpose","Total Balance","Interest Rate","# of Pmts","Current Principal Due","Accrued Interest","Total Pmt","Non-Current Principal","Final Year"]
[null,null,0,0,0,{"$f":"H65-G65","v":0},{"$f":"C65*D65","v":0},0,{"$f":"C65-F65","v":0}]
[null,null,0,0,0,0,{"$f":"C66*D66","v":0},0,0]
[null,null,0,0,0,0,{"$f":"C67*D67","v":0},0,0]
[null,null,0,0,0,0,{"$f":"C68*D68","v":0},0,0]
[null,null,0,0,0,0,{"$f":"C69*D69","v":0},0,0]
[null,null,0,0,0,0,{"$f":"C60*D70","v":0},0,0]
[null,null,0,0,0,0,{"$f":"C71*D71","v":0},0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
["Total",null,{"$f":"SUM(C65:C84)","v":0},null,null,{"$f":"SUM(F65:F84)","v":0},0,0,{"$f":"SUM(I65:I84)","v":0}]

{"sheet":"Assets (Personal)","index":5,"n_rows":73,"n_cols":7,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Personal Cash-On-Hand"]
["Description","Amount"]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
["Total Cash",{"$f":"SUM(B3:B12)","v":0}]
[]
[]
["Life Insurance"]
["Account Name","Description","Total Cost Value","Total Market Value"]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
["Total Insurance",null,{"$f":"SUM(C18:C27)","v":0},{"$f":"SUM(D18:D27)","v":0}]
[]
[]
["Retirement Account"]
["Account Name","Description","Total Cost Value","Total Market Value"]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
["Total Retirement",null,{"$f":"SUM(C33:C42)","v":0},{"$f":"SUM(D33:D42)","v":0}]
[]
[]
["Personal Vehicle"]
["Item Description","Make","Model","Year","Serial #","Total Cost Value","Total Market Value"]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
["Total Personal Vehicles",null,null,null,null,{"$f":"SUM(F48:F57)","v":0},{"$f":"SUM(G48:G57)","v":0}]
[]
[]
["Real Estate"]
["Description","Location","Total Acres","Crop Acres","Value/Acre","Total Cost Value","Total Market Value"]
[null,null,0,0,{"$f":"G63/C63","v":{"$error":"#DIV/0!"}},0,0]
[null,null,0,0,{"$error":"#DIV/0!"},0,0]
[null,null,0,0,{"$error":"#DIV/0!"},0,0]
[null,null,0,0,{"$error":"#DIV/0!"},0,0]
[null,null,0,0,{"$error":"#DIV/0!"},0,0]
[null,null,0,0,{"$error":"#DIV/0!"},0,0]
[null,null,0,0,{"$error":"#DIV/0!"},0,0]
[null,null,0,0,{"$error":"#DIV/0!"},0,0]
[null,null,0,0,{"$error":"#DIV/0!"},0,0]
[null,null,0,0,{"$error":"#DIV/0!"},0,0]
["Total",null,{"$f":"SUM(C63:C72)","v":0},0,{"$error":"#DIV/0!"},{"$f":"SUM(F63:F72)","v":0},{"$f":"SUM(G63:G72)","v":0}]

{"sheet":"Liabilities (Personal)","index":6,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["Accounts Payable (Personal)"]
["Account Description","Detail","Total Value"]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
["Total",null,{"$f":"SUM(C3:C12)","v":0}]
[]
[]
["Current Personal Loans"]
["Account Description","Loan Purpose","Total Balance","Interest Rate","# of Pmts","Current Principal Due","Accrued Interest","Total Annual Pmt"]
[null,null,0,0,0,{"$f":"H18-G18","v":0},{"$f":"C18*D18","v":0},0]
[null,null,0,0,0,{"$f":"H19-G19","v":0},0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,null,null,"*Note: ","Default accrued interest is calculation of loan balance multipled by interest rate."]
[null,null,0,0,0,0,0,0,null,null,null,"To personalize for your farm, enter accured interest amounts based on loan statements."]
[null,null,0,0,0,0,0,0,null,null,null,"Reset button will return accrued interest to default calculation."]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
["Total",null,{"$f":"SUM(C18:C27)","v":0},null,null,{"$f":"SUM(F18:F27)","v":0},{"$f":"SUM(G18:G27)","v":0},{"$f":"SUM(H18:H27)","v":0}]
[]
[]
["Intermediate Personal Loans"]
["Account Description","Loan Purpose","Total Balance","Interest Rate","# of Pmts","Current Principal Due","Accrued Interest","Total Annual Pmt","Non-Current Principal"]
[null,null,0,0,0,{"$f":"H33-G33","v":0},{"$f":"C33*D33","v":0},0,{"$f":"C33-F33","v":0}]
[null,null,0,0,0,{"$f":"H34-G34","v":0},0,0,{"$f":"C34-F34","v":0}]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
["Total",null,{"$f":"SUM(C33:C42)","v":0},null,null,{"$f":"SUM(F33:F42)","v":0},{"$f":"SUM(G33:G42)","v":0},{"$f":"SUM(H33:H42)","v":0},{"$f":"SUM(I33:I42)","v":0}]
[]
[]
["Long-Term Personal Loans"]
["Account Description","Loan Purpose","Total Balance","Interest Rate","# of Pmts","Current Principal Due","Accrued Interest","Total Annual Pmt","Non-Current Principal"]
[null,null,0,0,0,{"$f":"H48-G48","v":0},{"$f":"C48*D48","v":0},0,{"$f":"C48-F48","v":0}]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0]
["Total",null,{"$f":"SUM(C48:C57)","v":0},null,null,{"$f":"SUM(F48:F57)","v":0},0,{"$f":"SUM(H48:H57)","v":0},{"$f":"SUM(I48:I57)","v":0}]

{"sheet":"Financial Ratios","index":7,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,3,35,8],[0,0,0,1],[13,0,13,1],[26,0,26,1],[2,7,2,8],[0,3,0,8],[1,7,1,8],[14,7,14,8],[15,7,15,8]]}
["Farm",null,null,"Farm Financial Scorecard"]
["Liquidity",null,null,"Vulnerable",null,null,null,"Strong"]
["Working Capital",{"$f":"Summary!C13-Summary!F13","v":0},null,null,1.3,null,2]
["Current Ratio",{"$f":"Summary!C13/Summary!F13","v":{"$error":"#DIV/0!"}}]
[]
["Solvency",null,null,null,0.6,null,0.3]
["Debt/Asset",{"$f":"Summary!F27/Summary!C27","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,0.4,null,0.7]
["Equity/Asset",{"$f":"Summary!F28/Summary!C27","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,1.5,null,0.43]
["Debt/Equity",{"$f":"Summary!F27/Summary!F28","v":{"$error":"#DIV/0!"}}]
[]
[]
["Personal"]
["Liquidity"]
["Working Capital",{"$f":"Summary!C34-Summary!F34","v":0},null,null,1.3,null,2]
["Current Ratio",{"$f":"Summary!C34/Summary!F34","v":{"$error":"#DIV/0!"}}]
[]
["Solvency",null,null,null,0.6,null,0.3]
["Debt/Asset",{"$f":"Summary!F43/Summary!C43","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,0.4,null,0.7]
["Equity/Asset",{"$f":"Summary!F44/Summary!C43","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,1.5,null,0.43]
["Debt/Equity",{"$f":"Summary!F43/Summary!F44","v":{"$error":"#DIV/0!"}}]
[]
[]
["Total Farm & Personal"]
["Solvency",null,null,null,0.6,null,0.3]
["Debt/Asset",{"$f":"Summary!F46/Summary!C46","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,0.4,null,0.7]
["Equity/Asset",{"$f":"Summary!F47/Summary!C46","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,1.5,null,0.43]
["Debt/Equity",{"$f":"Summary!F46/Summary!F47","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,"Farm Financial Scorecard Document"]